<html lang="zh"> 
 <head></head> 
 <body style="text-align:center;">
   ﻿ 
  <title>xqxc_hotel文档</title> 
  <style type="text/css">body {            padding-bottom: 50px        }        body, td {            font-family: verdana, fantasy;            font-size: 12px;            line-height: 150%        }        table {            width: 100%;            background-color: #ccc;            margin: 5px 0        }        td {            background-color: #fff;            padding: 3px 3px 3px 10px        }        thead td {            text-align: center;            font-weight: bold;            background-color: #eee        }        a:link, a:visited, a:active {            color: #015fb6;            text-decoration: none        }        a:hover {            color: #e33e06        }</style> 
  <div style="width:800px; margin:20px auto; text-align:left;"> <a name="index"></a> 
   <h2 style="text-align:center; line-height:50px;">xqxc_hotel文档</h2> 
   <div> <b>数据库名：xqxc_hotel</b> 
    <br><b>文档版本：0.0.1-SNAPSHOT</b> 
    <br><b>文档描述：xqxc_hotel文档生成</b> 
    <br> 
   </div> 
   <table cellspacing="1"> 
    <thead> 
     <tr> 
      <td style="width:40px; ">序号</td> 
      <td>表名</td> 
      <td>说明</td> 
     </tr> 
    </thead> 
    <tbody> 
     <tr> 
      <td style="text-align:center;">1</td> 
      <td><a href="#com_area_info">com_area_info</a></td> 
      <td>地区表</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">2</td> 
      <td><a href="#homestay_level">homestay_level</a></td> 
      <td>民宿户型表</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">3</td> 
      <td><a href="#hotel_house_category">hotel_house_category</a></td> 
      <td>酒店房源分类表--废弃</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">4</td> 
      <td><a href="#hotel_house_info">hotel_house_info</a></td> 
      <td>酒店房源信息表-废弃</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">5</td> 
      <td><a href="#hotel_installation">hotel_installation</a></td> 
      <td>酒店设施表</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">6</td> 
      <td><a href="#hotel_live_house_log">hotel_live_house_log</a></td> 
      <td>酒店直播看房表</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">7</td> 
      <td><a href="#hotel_quick_order">hotel_quick_order</a></td> 
      <td>快速接单表</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">8</td> 
      <td><a href="#hotel_requirement">hotel_requirement</a></td> 
      <td>需求单表</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">9</td> 
      <td><a href="#hotel_star_level">hotel_star_level</a></td> 
      <td>酒店星级表</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">10</td> 
      <td><a href="#sys_hot_city">sys_hot_city</a></td> 
      <td>系统热门城市</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">11</td> 
      <td><a href="#sys_voice_packet">sys_voice_packet</a></td> 
      <td>系统语音包</td> 
     </tr> 
    </tbody> 
   </table><a name="com_area_info"></a> 
   <div style="margin-top:30px;" class="table_name"> <a href="#index" style="float:right; margin-top:6px;">返回目录</a><b>表名：com_area_info</b> 
   </div> 
   <div>
     说明：地区表 
   </div> 
   <div>
     数据列： 
   </div> 
   <table cellspacing="1"> 
    <thead> 
     <tr> 
      <td style="width:40px; ">序号</td> 
      <td>名称</td> 
      <td>数据类型</td> 
      <td>长度</td> 
      <td>小数位</td> 
      <td>允许空值</td> 
      <td>主键</td> 
      <td>默认值</td> 
      <td>说明</td> 
     </tr> 
    </thead> 
    <tbody> 
     <tr> 
      <td style="text-align:center;">1</td> 
      <td>id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">Y</td> 
      <td align="center"></td> 
      <td align="center">主键ID</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">2</td> 
      <td>area_name</td> 
      <td align="center">varchar</td> 
      <td align="center">50</td> 
      <td align="center">0</td> 
      <td align="center">Y</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">名称</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">3</td> 
      <td>parent_id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">Y</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">父id；null；；</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">4</td> 
      <td>short_name</td> 
      <td align="center">varchar</td> 
      <td align="center">50</td> 
      <td align="center">0</td> 
      <td align="center">Y</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">简称</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">5</td> 
      <td>level_type</td> 
      <td align="center">char</td> 
      <td align="center">1</td> 
      <td align="center">0</td> 
      <td align="center">Y</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">级别</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">6</td> 
      <td>area_code</td> 
      <td align="center">varchar</td> 
      <td align="center">4</td> 
      <td align="center">0</td> 
      <td align="center">Y</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">城市区号</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">7</td> 
      <td>zip_code</td> 
      <td align="center">varchar</td> 
      <td align="center">6</td> 
      <td align="center">0</td> 
      <td align="center">Y</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">邮编</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">8</td> 
      <td>merger_name</td> 
      <td align="center">varchar</td> 
      <td align="center">50</td> 
      <td align="center">0</td> 
      <td align="center">Y</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">全名</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">9</td> 
      <td>lng</td> 
      <td align="center">varchar</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">Y</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">经度</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">10</td> 
      <td>lat</td> 
      <td align="center">varchar</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">Y</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">纬度</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">11</td> 
      <td>pinyin</td> 
      <td align="center">varchar</td> 
      <td align="center">30</td> 
      <td align="center">0</td> 
      <td align="center">Y</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">拼音</td> 
     </tr> 
    </tbody> 
   </table><a name="homestay_level"></a> 
   <div style="margin-top:30px;" class="table_name"> <a href="#index" style="float:right; margin-top:6px;">返回目录</a><b>表名：homestay_level</b> 
   </div> 
   <div>
     说明：民宿户型表 
   </div> 
   <div>
     数据列： 
   </div> 
   <table cellspacing="1"> 
    <thead> 
     <tr> 
      <td style="width:40px; ">序号</td> 
      <td>名称</td> 
      <td>数据类型</td> 
      <td>长度</td> 
      <td>小数位</td> 
      <td>允许空值</td> 
      <td>主键</td> 
      <td>默认值</td> 
      <td>说明</td> 
     </tr> 
    </thead> 
    <tbody> 
     <tr> 
      <td style="text-align:center;">1</td> 
      <td>id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">Y</td> 
      <td align="center"></td> 
      <td align="center">主键</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">2</td> 
      <td>name</td> 
      <td align="center">varchar</td> 
      <td align="center">512</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">名称</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">3</td> 
      <td>create_user_id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">创建人id</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">4</td> 
      <td>create_user_name</td> 
      <td align="center">varchar</td> 
      <td align="center">32</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">创建人</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">5</td> 
      <td>gmt_create</td> 
      <td align="center">timestamp</td> 
      <td align="center">19</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">CURRENT_TIMESTAMP(3)</td> 
      <td align="center">创建时间</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">6</td> 
      <td>modify_user_id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">修改人id</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">7</td> 
      <td>modify_user_name</td> 
      <td align="center">varchar</td> 
      <td align="center">32</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">修改人</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">8</td> 
      <td>gmt_modified</td> 
      <td align="center">timestamp</td> 
      <td align="center">19</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">CURRENT_TIMESTAMP(3)</td> 
      <td align="center">修改时间</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">9</td> 
      <td>is_delete</td> 
      <td align="center">tinyint</td> 
      <td align="center">4</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">是否删除(0否1是)</td> 
     </tr> 
    </tbody> 
   </table><a name="hotel_house_category"></a> 
   <div style="margin-top:30px;" class="table_name"> <a href="#index" style="float:right; margin-top:6px;">返回目录</a><b>表名：hotel_house_category</b> 
   </div> 
   <div>
     说明：酒店房源分类表--废弃 
   </div> 
   <div>
     数据列： 
   </div> 
   <table cellspacing="1"> 
    <thead> 
     <tr> 
      <td style="width:40px; ">序号</td> 
      <td>名称</td> 
      <td>数据类型</td> 
      <td>长度</td> 
      <td>小数位</td> 
      <td>允许空值</td> 
      <td>主键</td> 
      <td>默认值</td> 
      <td>说明</td> 
     </tr> 
    </thead> 
    <tbody> 
     <tr> 
      <td style="text-align:center;">1</td> 
      <td>id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">Y</td> 
      <td align="center"></td> 
      <td align="center">主键</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">2</td> 
      <td>category_name</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">分类名称</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">3</td> 
      <td>plat_rate</td> 
      <td align="center">decimal</td> 
      <td align="center">12</td> 
      <td align="center">2</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">平台费率</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">4</td> 
      <td>agent_rate</td> 
      <td align="center">decimal</td> 
      <td align="center">12</td> 
      <td align="center">2</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">技术服务费率</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">5</td> 
      <td>sort_no</td> 
      <td align="center">int</td> 
      <td align="center">10</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">排序</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">6</td> 
      <td>type</td> 
      <td align="center">varchar</td> 
      <td align="center">32</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">分类类型(酒店,民宿)</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">7</td> 
      <td>create_user_id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">创建人id</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">8</td> 
      <td>create_user_name</td> 
      <td align="center">varchar</td> 
      <td align="center">32</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">创建人</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">9</td> 
      <td>gmt_create</td> 
      <td align="center">timestamp</td> 
      <td align="center">19</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">CURRENT_TIMESTAMP(3)</td> 
      <td align="center">创建时间</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">10</td> 
      <td>modify_user_id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">修改人id</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">11</td> 
      <td>modify_user_name</td> 
      <td align="center">varchar</td> 
      <td align="center">32</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">修改人</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">12</td> 
      <td>gmt_modified</td> 
      <td align="center">timestamp</td> 
      <td align="center">19</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">CURRENT_TIMESTAMP(3)</td> 
      <td align="center">修改时间</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">13</td> 
      <td>is_delete</td> 
      <td align="center">tinyint</td> 
      <td align="center">4</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">是否删除(0否1是)</td> 
     </tr> 
    </tbody> 
   </table><a name="hotel_house_info"></a> 
   <div style="margin-top:30px;" class="table_name"> <a href="#index" style="float:right; margin-top:6px;">返回目录</a><b>表名：hotel_house_info</b> 
   </div> 
   <div>
     说明：酒店房源信息表-废弃 
   </div> 
   <div>
     数据列： 
   </div> 
   <table cellspacing="1"> 
    <thead> 
     <tr> 
      <td style="width:40px; ">序号</td> 
      <td>名称</td> 
      <td>数据类型</td> 
      <td>长度</td> 
      <td>小数位</td> 
      <td>允许空值</td> 
      <td>主键</td> 
      <td>默认值</td> 
      <td>说明</td> 
     </tr> 
    </thead> 
    <tbody> 
     <tr> 
      <td style="text-align:center;">1</td> 
      <td>id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">Y</td> 
      <td align="center"></td> 
      <td align="center">主键</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">2</td> 
      <td>merchant_id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">商户id；null；xqxc_merchant.merchant_info；xqxc_merchant.merchant_info</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">3</td> 
      <td>shop_id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">店铺id；null；xqxc_merchant.shop_info；xqxc_merchant.shop_info</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">4</td> 
      <td>house_name</td> 
      <td align="center">varchar</td> 
      <td align="center">512</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">房源名称</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">5</td> 
      <td>house_type_id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">房源房型类型；null；；</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">6</td> 
      <td>house_cover</td> 
      <td align="center">varchar</td> 
      <td align="center">512</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">房源封面</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">7</td> 
      <td>market_price</td> 
      <td align="center">varchar</td> 
      <td align="center">512</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">市场价</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">8</td> 
      <td>sale_price</td> 
      <td align="center">varchar</td> 
      <td align="center">512</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">销售价</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">9</td> 
      <td>min_price</td> 
      <td align="center">varchar</td> 
      <td align="center">512</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">最低平台价格</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">10</td> 
      <td>status</td> 
      <td align="center">varchar</td> 
      <td align="center">512</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">状态(上架,下架,禁用)</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">11</td> 
      <td>house_area</td> 
      <td align="center">varchar</td> 
      <td align="center">512</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">房源面积</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">12</td> 
      <td>breakfast_flag</td> 
      <td align="center">tinyint</td> 
      <td align="center">4</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">是否含早(0否1是)</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">13</td> 
      <td>base_settings</td> 
      <td align="center">varchar</td> 
      <td align="center">512</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">房源设施jsno串</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">14</td> 
      <td>video_url</td> 
      <td align="center">varchar</td> 
      <td align="center">128</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">视频url</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">15</td> 
      <td>img_urls</td> 
      <td align="center">varchar</td> 
      <td align="center">512</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">[]</td> 
      <td align="center">图片json数组</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">16</td> 
      <td>create_user_id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">创建人id</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">17</td> 
      <td>create_user_name</td> 
      <td align="center">varchar</td> 
      <td align="center">32</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">创建人</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">18</td> 
      <td>gmt_create</td> 
      <td align="center">timestamp</td> 
      <td align="center">19</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">CURRENT_TIMESTAMP(3)</td> 
      <td align="center">创建时间</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">19</td> 
      <td>modify_user_id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">修改人id</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">20</td> 
      <td>modify_user_name</td> 
      <td align="center">varchar</td> 
      <td align="center">32</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">修改人</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">21</td> 
      <td>gmt_modified</td> 
      <td align="center">timestamp</td> 
      <td align="center">19</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">CURRENT_TIMESTAMP(3)</td> 
      <td align="center">修改时间</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">22</td> 
      <td>is_delete</td> 
      <td align="center">tinyint</td> 
      <td align="center">4</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">是否删除(0否1是)</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">23</td> 
      <td>is_home_reco</td> 
      <td align="center">tinyint</td> 
      <td align="center">4</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">列表推介</td> 
     </tr> 
    </tbody> 
   </table><a name="hotel_installation"></a> 
   <div style="margin-top:30px;" class="table_name"> <a href="#index" style="float:right; margin-top:6px;">返回目录</a><b>表名：hotel_installation</b> 
   </div> 
   <div>
     说明：酒店设施表 
   </div> 
   <div>
     数据列： 
   </div> 
   <table cellspacing="1"> 
    <thead> 
     <tr> 
      <td style="width:40px; ">序号</td> 
      <td>名称</td> 
      <td>数据类型</td> 
      <td>长度</td> 
      <td>小数位</td> 
      <td>允许空值</td> 
      <td>主键</td> 
      <td>默认值</td> 
      <td>说明</td> 
     </tr> 
    </thead> 
    <tbody> 
     <tr> 
      <td style="text-align:center;">1</td> 
      <td>id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">Y</td> 
      <td align="center"></td> 
      <td align="center">主键</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">2</td> 
      <td>name</td> 
      <td align="center">varchar</td> 
      <td align="center">512</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">设施名称</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">3</td> 
      <td>status</td> 
      <td align="center">tinyint</td> 
      <td align="center">4</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">1</td> 
      <td align="center">状态(0-禁用,1-启用)</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">4</td> 
      <td>icon_url</td> 
      <td align="center">varchar</td> 
      <td align="center">128</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">图标url</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">5</td> 
      <td>type</td> 
      <td align="center">varchar</td> 
      <td align="center">32</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">设施类型(酒店,房间)</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">6</td> 
      <td>create_user_id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">创建人id</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">7</td> 
      <td>create_user_name</td> 
      <td align="center">varchar</td> 
      <td align="center">32</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">创建人</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">8</td> 
      <td>gmt_create</td> 
      <td align="center">timestamp</td> 
      <td align="center">19</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">CURRENT_TIMESTAMP(3)</td> 
      <td align="center">创建时间</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">9</td> 
      <td>modify_user_id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">修改人id</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">10</td> 
      <td>modify_user_name</td> 
      <td align="center">varchar</td> 
      <td align="center">32</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">修改人</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">11</td> 
      <td>gmt_modified</td> 
      <td align="center">timestamp</td> 
      <td align="center">19</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">CURRENT_TIMESTAMP(3)</td> 
      <td align="center">修改时间</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">12</td> 
      <td>is_delete</td> 
      <td align="center">tinyint</td> 
      <td align="center">4</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">是否删除(0否1是)</td> 
     </tr> 
    </tbody> 
   </table><a name="hotel_live_house_log"></a> 
   <div style="margin-top:30px;" class="table_name"> <a href="#index" style="float:right; margin-top:6px;">返回目录</a><b>表名：hotel_live_house_log</b> 
   </div> 
   <div>
     说明：酒店直播看房表 
   </div> 
   <div>
     数据列： 
   </div> 
   <table cellspacing="1"> 
    <thead> 
     <tr> 
      <td style="width:40px; ">序号</td> 
      <td>名称</td> 
      <td>数据类型</td> 
      <td>长度</td> 
      <td>小数位</td> 
      <td>允许空值</td> 
      <td>主键</td> 
      <td>默认值</td> 
      <td>说明</td> 
     </tr> 
    </thead> 
    <tbody> 
     <tr> 
      <td style="text-align:center;">1</td> 
      <td>id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">Y</td> 
      <td align="center"></td> 
      <td align="center">主键</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">2</td> 
      <td>channel_id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">通道id；null；；</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">3</td> 
      <td>call_state</td> 
      <td align="center">varchar</td> 
      <td align="center">32</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">直播状态</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">4</td> 
      <td>from_id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">发起方id；null；；</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">5</td> 
      <td>to_id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">接受方id；null；；</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">6</td> 
      <td>from_type</td> 
      <td align="center">varchar</td> 
      <td align="center">32</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">发起方类型</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">7</td> 
      <td>business_id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">业务主键id；null；；</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">8</td> 
      <td>duration</td> 
      <td align="center">int</td> 
      <td align="center">10</td> 
      <td align="center">0</td> 
      <td align="center">Y</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">时长</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">9</td> 
      <td>user_name</td> 
      <td align="center">varchar</td> 
      <td align="center">64</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">用户昵称</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">10</td> 
      <td>header</td> 
      <td align="center">varchar</td> 
      <td align="center">255</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">头像</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">11</td> 
      <td>gmt_create</td> 
      <td align="center">timestamp</td> 
      <td align="center">19</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">CURRENT_TIMESTAMP(3)</td> 
      <td align="center">创建时间</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">12</td> 
      <td>gmt_modified</td> 
      <td align="center">timestamp</td> 
      <td align="center">19</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">CURRENT_TIMESTAMP(3)</td> 
      <td align="center">修改时间</td> 
     </tr> 
    </tbody> 
   </table><a name="hotel_quick_order"></a> 
   <div style="margin-top:30px;" class="table_name"> <a href="#index" style="float:right; margin-top:6px;">返回目录</a><b>表名：hotel_quick_order</b> 
   </div> 
   <div>
     说明：快速接单表 
   </div> 
   <div>
     数据列： 
   </div> 
   <table cellspacing="1"> 
    <thead> 
     <tr> 
      <td style="width:40px; ">序号</td> 
      <td>名称</td> 
      <td>数据类型</td> 
      <td>长度</td> 
      <td>小数位</td> 
      <td>允许空值</td> 
      <td>主键</td> 
      <td>默认值</td> 
      <td>说明</td> 
     </tr> 
    </thead> 
    <tbody> 
     <tr> 
      <td style="text-align:center;">1</td> 
      <td>id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">Y</td> 
      <td align="center"></td> 
      <td align="center">主键</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">2</td> 
      <td>hotel_id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">接单酒店（商户）id；null；；</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">3</td> 
      <td>requirement_id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">需求单id；null；；</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">4</td> 
      <td>gmt_create</td> 
      <td align="center">timestamp</td> 
      <td align="center">19</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">CURRENT_TIMESTAMP(3)</td> 
      <td align="center">创建时间</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">5</td> 
      <td>shop_id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">Y</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">店铺id；null；xqxc_merchant.shop_info；xqxc_merchant.shop_info</td> 
     </tr> 
    </tbody> 
   </table><a name="hotel_requirement"></a> 
   <div style="margin-top:30px;" class="table_name"> <a href="#index" style="float:right; margin-top:6px;">返回目录</a><b>表名：hotel_requirement</b> 
   </div> 
   <div>
     说明：需求单表 
   </div> 
   <div>
     数据列： 
   </div> 
   <table cellspacing="1"> 
    <thead> 
     <tr> 
      <td style="width:40px; ">序号</td> 
      <td>名称</td> 
      <td>数据类型</td> 
      <td>长度</td> 
      <td>小数位</td> 
      <td>允许空值</td> 
      <td>主键</td> 
      <td>默认值</td> 
      <td>说明</td> 
     </tr> 
    </thead> 
    <tbody> 
     <tr> 
      <td style="text-align:center;">1</td> 
      <td>id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">Y</td> 
      <td align="center"></td> 
      <td align="center">主键</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">2</td> 
      <td>user_id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">会员id；null；；</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">3</td> 
      <td>hotel_id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">接单酒店（商户）id；null；；</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">4</td> 
      <td>shop_id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">店铺id；null；xqxc_merchant.shop_info；xqxc_merchant.shop_info</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">5</td> 
      <td>destination</td> 
      <td align="center">varchar</td> 
      <td align="center">255</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">住宿地</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">6</td> 
      <td>destination_latitude</td> 
      <td align="center">varchar</td> 
      <td align="center">64</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">住宿地维度</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">7</td> 
      <td>destination_longitude</td> 
      <td align="center">varchar</td> 
      <td align="center">64</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">住宿地经度</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">8</td> 
      <td>type</td> 
      <td align="center">varchar</td> 
      <td align="center">64</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">类型：酒店 或 民宿/公寓</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">9</td> 
      <td>hotel_level</td> 
      <td align="center">varchar</td> 
      <td align="center">64</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">星级</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">10</td> 
      <td>hotel_level_id</td> 
      <td align="center">varchar</td> 
      <td align="center">64</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">星级id集合；null；；</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">11</td> 
      <td>house_type_id</td> 
      <td align="center">varchar</td> 
      <td align="center">64</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">房型id集合；null；；</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">12</td> 
      <td>house_type</td> 
      <td align="center">varchar</td> 
      <td align="center">256</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">房型</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">13</td> 
      <td>budget_price</td> 
      <td align="center">int</td> 
      <td align="center">10</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">预算价格</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">14</td> 
      <td>rooms</td> 
      <td align="center">int</td> 
      <td align="center">10</td> 
      <td align="center">0</td> 
      <td align="center">Y</td> 
      <td align="center">N</td> 
      <td align="center">1</td> 
      <td align="center">房间数</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">15</td> 
      <td>additional_price</td> 
      <td align="center">int</td> 
      <td align="center">10</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">加价</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">16</td> 
      <td>additional_price_state</td> 
      <td align="center">tinyint</td> 
      <td align="center">4</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">0：未加价 1：加价1次</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">17</td> 
      <td>search_range</td> 
      <td align="center">int</td> 
      <td align="center">10</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">搜索范围</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">18</td> 
      <td>search_range_state</td> 
      <td align="center">tinyint</td> 
      <td align="center">4</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">0：未扩大 1：扩大1次</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">19</td> 
      <td>status</td> 
      <td align="center">varchar</td> 
      <td align="center">32</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">状态(1：待接单 2：待确认 3：用户取消；4：酒店取消；5：超时取消)</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">20</td> 
      <td>in_time</td> 
      <td align="center">timestamp</td> 
      <td align="center">19</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">CURRENT_TIMESTAMP(3)</td> 
      <td align="center">入住时间</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">21</td> 
      <td>out_time</td> 
      <td align="center">timestamp</td> 
      <td align="center">19</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">CURRENT_TIMESTAMP(3)</td> 
      <td align="center">离店时间</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">22</td> 
      <td>quit_wait_time</td> 
      <td align="center">timestamp</td> 
      <td align="center">19</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">CURRENT_TIMESTAMP(3)</td> 
      <td align="center">结束等待时间</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">23</td> 
      <td>gmt_create</td> 
      <td align="center">timestamp</td> 
      <td align="center">19</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">CURRENT_TIMESTAMP(3)</td> 
      <td align="center">创建时间</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">24</td> 
      <td>gmt_modified</td> 
      <td align="center">timestamp</td> 
      <td align="center">19</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">CURRENT_TIMESTAMP(3)</td> 
      <td align="center">修改时间</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">25</td> 
      <td>invitation_state</td> 
      <td align="center">tinyint</td> 
      <td align="center">4</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">邀请入住标识（0：未邀请 1：已邀请）</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">26</td> 
      <td>hotel_name</td> 
      <td align="center">varchar</td> 
      <td align="center">255</td> 
      <td align="center">0</td> 
      <td align="center">Y</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">酒店名称</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">27</td> 
      <td>order_id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">订单ID；null；xqxc_order.order_info；xqxc_order.order_info</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">28</td> 
      <td>receiving_time</td> 
      <td align="center">datetime</td> 
      <td align="center">19</td> 
      <td align="center">0</td> 
      <td align="center">Y</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">接单时间</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">29</td> 
      <td>user_avatar</td> 
      <td align="center">varchar</td> 
      <td align="center">200</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">用户头像</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">30</td> 
      <td>user_phone</td> 
      <td align="center">varchar</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">用户手机</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">31</td> 
      <td>user_nickname</td> 
      <td align="center">varchar</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">用户昵称</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">32</td> 
      <td>side_type</td> 
      <td align="center">varchar</td> 
      <td align="center">16</td> 
      <td align="center">0</td> 
      <td align="center">Y</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">终端操作系统类型：ANDROID,IOS</td> 
     </tr> 
    </tbody> 
   </table><a name="hotel_star_level"></a> 
   <div style="margin-top:30px;" class="table_name"> <a href="#index" style="float:right; margin-top:6px;">返回目录</a><b>表名：hotel_star_level</b> 
   </div> 
   <div>
     说明：酒店星级表 
   </div> 
   <div>
     数据列： 
   </div> 
   <table cellspacing="1"> 
    <thead> 
     <tr> 
      <td style="width:40px; ">序号</td> 
      <td>名称</td> 
      <td>数据类型</td> 
      <td>长度</td> 
      <td>小数位</td> 
      <td>允许空值</td> 
      <td>主键</td> 
      <td>默认值</td> 
      <td>说明</td> 
     </tr> 
    </thead> 
    <tbody> 
     <tr> 
      <td style="text-align:center;">1</td> 
      <td>id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">Y</td> 
      <td align="center"></td> 
      <td align="center">主键</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">2</td> 
      <td>name</td> 
      <td align="center">varchar</td> 
      <td align="center">512</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">名称</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">3</td> 
      <td>icon_url</td> 
      <td align="center">varchar</td> 
      <td align="center">128</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">图标url</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">4</td> 
      <td>create_user_id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">创建人id</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">5</td> 
      <td>create_user_name</td> 
      <td align="center">varchar</td> 
      <td align="center">32</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">创建人</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">6</td> 
      <td>gmt_create</td> 
      <td align="center">timestamp</td> 
      <td align="center">19</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">CURRENT_TIMESTAMP(3)</td> 
      <td align="center">创建时间</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">7</td> 
      <td>modify_user_id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">修改人id</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">8</td> 
      <td>modify_user_name</td> 
      <td align="center">varchar</td> 
      <td align="center">32</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">修改人</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">9</td> 
      <td>gmt_modified</td> 
      <td align="center">timestamp</td> 
      <td align="center">19</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">CURRENT_TIMESTAMP(3)</td> 
      <td align="center">修改时间</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">10</td> 
      <td>is_delete</td> 
      <td align="center">tinyint</td> 
      <td align="center">4</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">是否删除(0否1是)</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">11</td> 
      <td>status</td> 
      <td align="center">tinyint</td> 
      <td align="center">4</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">1</td> 
      <td align="center">开启状态（默认开启：1，关闭：0）</td> 
     </tr> 
    </tbody> 
   </table><a name="sys_hot_city"></a> 
   <div style="margin-top:30px;" class="table_name"> <a href="#index" style="float:right; margin-top:6px;">返回目录</a><b>表名：sys_hot_city</b> 
   </div> 
   <div>
     说明：系统热门城市 
   </div> 
   <div>
     数据列： 
   </div> 
   <table cellspacing="1"> 
    <thead> 
     <tr> 
      <td style="width:40px; ">序号</td> 
      <td>名称</td> 
      <td>数据类型</td> 
      <td>长度</td> 
      <td>小数位</td> 
      <td>允许空值</td> 
      <td>主键</td> 
      <td>默认值</td> 
      <td>说明</td> 
     </tr> 
    </thead> 
    <tbody> 
     <tr> 
      <td style="text-align:center;">1</td> 
      <td>id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">Y</td> 
      <td align="center"></td> 
      <td align="center">主键</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">2</td> 
      <td>name</td> 
      <td align="center">varchar</td> 
      <td align="center">512</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">城市名称</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">3</td> 
      <td>first_char</td> 
      <td align="center">varchar</td> 
      <td align="center">3</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">首字母</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">4</td> 
      <td>flag</td> 
      <td align="center">int</td> 
      <td align="center">10</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">是否为热门城市(0-否,1-是)</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">5</td> 
      <td>sort_no</td> 
      <td align="center">int</td> 
      <td align="center">10</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">排序</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">6</td> 
      <td>create_user_id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">创建人id</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">7</td> 
      <td>create_user_name</td> 
      <td align="center">varchar</td> 
      <td align="center">32</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">创建人</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">8</td> 
      <td>gmt_create</td> 
      <td align="center">timestamp</td> 
      <td align="center">19</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">CURRENT_TIMESTAMP(3)</td> 
      <td align="center">创建时间</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">9</td> 
      <td>modify_user_id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">修改人id</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">10</td> 
      <td>modify_user_name</td> 
      <td align="center">varchar</td> 
      <td align="center">32</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">修改人</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">11</td> 
      <td>gmt_modified</td> 
      <td align="center">timestamp</td> 
      <td align="center">19</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">CURRENT_TIMESTAMP(3)</td> 
      <td align="center">修改时间</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">12</td> 
      <td>is_delete</td> 
      <td align="center">tinyint</td> 
      <td align="center">4</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">是否删除(0否1是)</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">13</td> 
      <td>lng</td> 
      <td align="center">varchar</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center"></td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">14</td> 
      <td>lat</td> 
      <td align="center">varchar</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center"></td> 
     </tr> 
    </tbody> 
   </table><a name="sys_voice_packet"></a> 
   <div style="margin-top:30px;" class="table_name"> <a href="#index" style="float:right; margin-top:6px;">返回目录</a><b>表名：sys_voice_packet</b> 
   </div> 
   <div>
     说明：系统语音包 
   </div> 
   <div>
     数据列： 
   </div> 
   <table cellspacing="1"> 
    <thead> 
     <tr> 
      <td style="width:40px; ">序号</td> 
      <td>名称</td> 
      <td>数据类型</td> 
      <td>长度</td> 
      <td>小数位</td> 
      <td>允许空值</td> 
      <td>主键</td> 
      <td>默认值</td> 
      <td>说明</td> 
     </tr> 
    </thead> 
    <tbody> 
     <tr> 
      <td style="text-align:center;">1</td> 
      <td>id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">Y</td> 
      <td align="center"></td> 
      <td align="center">主键</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">2</td> 
      <td>name</td> 
      <td align="center">varchar</td> 
      <td align="center">512</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">语音包名称</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">3</td> 
      <td>status</td> 
      <td align="center">tinyint</td> 
      <td align="center">4</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">1</td> 
      <td align="center">状态(0-禁用,1-启用)</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">4</td> 
      <td>url</td> 
      <td align="center">varchar</td> 
      <td align="center">500</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">语音包url</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">5</td> 
      <td>application</td> 
      <td align="center">varchar</td> 
      <td align="center">512</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">应用端口</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">6</td> 
      <td>create_user_id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">创建人id</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">7</td> 
      <td>create_user_name</td> 
      <td align="center">varchar</td> 
      <td align="center">32</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">创建人</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">8</td> 
      <td>gmt_create</td> 
      <td align="center">timestamp</td> 
      <td align="center">19</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">CURRENT_TIMESTAMP(3)</td> 
      <td align="center">创建时间</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">9</td> 
      <td>modify_user_id</td> 
      <td align="center">bigint</td> 
      <td align="center">20</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">修改人id</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">10</td> 
      <td>modify_user_name</td> 
      <td align="center">varchar</td> 
      <td align="center">32</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center"></td> 
      <td align="center">修改人</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">11</td> 
      <td>gmt_modified</td> 
      <td align="center">timestamp</td> 
      <td align="center">19</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">CURRENT_TIMESTAMP(3)</td> 
      <td align="center">修改时间</td> 
     </tr> 
     <tr> 
      <td style="text-align:center;">12</td> 
      <td>is_delete</td> 
      <td align="center">tinyint</td> 
      <td align="center">4</td> 
      <td align="center">0</td> 
      <td align="center">N</td> 
      <td align="center">N</td> 
      <td align="center">0</td> 
      <td align="center">是否删除(0否1是)</td> 
     </tr> 
    </tbody> 
   </table> 
  </div> 
  <footer></footer>  
 </body>
</html>
